﻿	CREATE TABLE public.project
	(
	    /***************************************************************************************************
	    **  Table:	    public.project
	    **  Author:		Zhixian Ong
	    **
	    **  Description:
	    **    
	    **    List of registered projects.
	    **
	    **  Fields (3):
	    **
	    **      Id      - Defaults to nextval('project_id_seq')
	    **      Name    - Required unique user-input value
	    **      Alias   - Required user-input value
	    **
	    **  Constaints (2):
	    **
	    **      project_pk - 
	    **      project_uc - 
	    **
	    **  Modification History:
	    **
	    **      20140102  Zhixian Ong     - Initial prototype
	    ** 
	    **  Status:
	    **
	    **      Dev
	    ** 
	    ***************************************************************************************************/
        
	    -- [Fields]
	    id              integer                NOT NULL DEFAULT nextval('project_id_seq'), 
	    name            character varying(128) NOT NULL, 
	    alias           character varying(128) NULL, 
	    project_type_id integer,
        
	    -- [Constraints]
	    CONSTRAINT project_pk PRIMARY KEY (id),
	    CONSTRAINT project_uc UNIQUE (name)
	);